CrazyK Posted September 13, 2006 Share Posted September 13, 2006 Hi, habe a problem to connect to the database. We're using Gupta SQL Base. I made some tries but nothing really works. 1. I tried to use the JDBC-Driver delivered with the db. I added the JAR to the classpath. When setting up a new connection I entered the following: JDBC-Driver: jdbc.gupta.sqlbase.SqlbaseDriverJDBC URL: jdbc:sqlbase://192.168.xx.xx:2155/DBusername: SYSADMpassword: XXX but I get an error:general problem null, please check your username and password. The next problem with this jdbc-driver is that we use a custom country-file. In a java-sample it looks like this: Code:String s1 = "A B C D E F G H I J K L M N O P Q R S T U V W X Y Z \C4 \D6 \DC "; String s2 = "a b c d e f g h i j k l m n o p q r s t u v w x y z \E4 \F6 \FC \DF"; String s3 = s1.concat(s2); //Set the Whitespace settings for the country as in country.sql jdbc.gupta.sqlbase.SqlbaseDriver.SetCountryWhiteSpace("\9 \A \D \20"«»); //Set the Numeric settings for the country as in country.sql jdbc.gupta.sqlbase.SqlbaseDriver.SetCountryNumeric("0 1 2 3 4 5 6 7 8 9"«»); //Set the Alpha settings for the country as in country.sql jdbc.gupta.sqlbase.SqlbaseDriver.SetCountryAlpha(s3); 2. then tried using the jdbc-odbc-bridge from sun. but when using the button "test" iReport crashes without any error-message. It just close. ok.. thats it. would be nice if somebody could help me with that problem. Maybe there is a way to use a javaBean to connect to the database. So I could use the JDBC-Driver with the right country-code in the bean. But I have no Idea how to use this. maybe someone has a sample for this. Thanks for help MarcoPost edited by: CrazyK, at: 2006/09/13 06:52 Link to comment Share on other sites More sharing options...
CrazyK Posted September 14, 2006 Author Share Posted September 14, 2006 nobody an idea? Link to comment Share on other sites More sharing options...
aronrodrigues Posted September 14, 2006 Share Posted September 14, 2006 Can you connect to the db outside the report tool? Is the login information correct? Check in your db provider site for a sample of connection string. And make a java program only to connect. Then tell us if it worked. Link to comment Share on other sites More sharing options...
leroyg Posted September 15, 2006 Share Posted September 15, 2006 Hi I had a simular problem with Oracle, try copying the jdbc jar file you got into the lib directory of iReports, restart iReports. Hope that helps. Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted September 16, 2006 Share Posted September 16, 2006 To better understand where the problem is, run iReport using iReport.bat, so we can see a stacktrace, but looks like an error related to the driver. About the crash, it looks like a JVM crash. This kind of errors sometimes can be solved changing the JVM version. Giulio Link to comment Share on other sites More sharing options...
ismails Posted February 23, 2013 Share Posted February 23, 2013 It's too late but it may help someone;I had faced with the same problem as well, I was calling a stored process which took two parameters. I was sending one parameter. You may be you have the same mistake. by the way in ireport 4.5.1 it gives the warning that you have to give two parameters but ireport 4.8.0 does not give this warning, it just give he null check bla bla error.example:proper form of function calling => exec sp_myStoredProcess param1 param2(which I forgot to send)what was I did in ireport v 4.8.0 => exec sp_myStoredProcess param1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now