Tagged Questions
0
votes
0answers
34 views
Configurating BI Vanilla server 4.2
I'm currently working on a business intelligence project. I built the datawarehouse (including 5 datamarts) in SQL Server 2005. As BI tools, I did the ETL step using Pentaho Kettle and it worked just ...
0
votes
3answers
85 views
Protege Owl API DB to OWL
I need to create OWL class from the first table name if cardinality 1:1 and OWL class from the second table name. If cardinality 1:* and one of tables describes object properties, create OWL object ...
0
votes
0answers
265 views
JDBC connection to MSSQL server in windows authentication mode
In my following programme I am trying to connect MSSQL Server using jdbc in windows authentication. But getting following error
import java.io.*;
import java.sql.*;
import ...
1
vote
1answer
86 views
MSSQL - Invalid column name with Java/JTDS and Join
I want to execute the following statement using Java with JTDS in MSSQL 2005. I need it that way, because I want to show the results from position 1-15, 16-30 etc.
SELECT TOP 15 WID,AID,de FROM
...
-1
votes
1answer
203 views
ORA-29532: Java call terminated by uncaught Java exception- 2005-2008 migration error
I am using a C# application which will use both oracle and SQl 2005 for db connection. Recently we are migrating our SQL Server 2005 to Sql 2008. When i try to import my table to sql database using ...
0
votes
1answer
622 views
SQL Server jdbc connection
I am running this code snippet on localhost in windows authentication
but getting following error but I have alreadily added sqljdbc4 jar in my class path
and while running from eclipse also I have ...
2
votes
1answer
576 views
The document has no pages. Jasper Report
I'm having a problem searching for a solution to this issue. My codes works fine after I run it. It suppose to display the data on my sql database to my jtable, and there's a button that will trigger ...
3
votes
1answer
305 views
Populating JTable with data in SQL database
This one is related to THIS question which I asked before, this one kinda solve my problem but another problem came up and I'm asking myself 'why is that?'.
here is the codes (BTW I used r2xml.jar in ...
12
votes
5answers
557 views
SELECT statement in JAVA
public void search() throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:******";
String user = "*****";
...
0
votes
1answer
125 views
Updating data on sql using java swing [closed]
I have a problem with my codes, dunno how to fix it, because I've been doing it over and over again... and same error occurred can anyone tell me what to do?
Here is my codes :
For my connection ...
1
vote
1answer
137 views
Populate jTable in JAVA
Why do I have these error? what does it mean? I only want to display all the data on my SQL DB.
run:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at ...
1
vote
3answers
125 views
Conversion of data type in JAVA
I'm running my program and I have this error :
'[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type char to data type money, table 'OJT.dbo.Patients', column ...
1
vote
3answers
139 views
Insert data on SQL
I'm trying to insert data to my database on sql and after I run my program an error occured and says :
[Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error: Column name or number of supplied ...
1
vote
2answers
123 views
Displaying data from JDBC select statement [closed]
I am creating a program that is going to allow for displaying and manipulating data from my database. I wrote the following code based on a tutorial I found:
public class JavaApplication25 {
...
1
vote
2answers
106 views
TCP/IP (Java Application to SQL Server)
I try to know if I can connect Java to SQL Server using these codes :
package pkgtry;
import java.sql.*;
public class NewMain {
public static void main(String[] args) {
String ...
