Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » jdbc driver(connection problem)
jdbc driver [message #730787] Thu, 29 September 2011 07:29 Go to next message
bppt Missing name is currently offline bppt Missing nameFriend
Messages: 6
Registered: September 2011
Junior Member
Hi everyone,

I am happy to be one of the birt user,

I have tried to connect different db to generate report

I am able to connect the odbc-jdbc from ms access (.mdb) &

flatfile (.csv)

But i cannot connect to mysql successfully.

I have download the driver bundle with mysql server.
the mysql-connector-java-5.1.15-bin.jar

I have added to the "jar files"
I tried this "jdbc:mysql://localhost:3306/abc"

when i clicked test connection, there was no response.

I read through the internet but i am still in this problem,

pls. help. thx.
Re: jdbc driver [message #730944 is a reply to message #730787] Thu, 29 September 2011 15:12 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Remove it from the jar files and use the manage drivers button in the
jdbc data source or just copy it to
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers

Jason

On 9/29/2011 3:29 AM, bppt wrote:
> "jar files"
Re: jdbc driver [message #731441 is a reply to message #730944] Sat, 01 October 2011 02:48 Go to previous messageGo to next message
bppt Missing name is currently offline bppt Missing nameFriend
Messages: 6
Registered: September 2011
Junior Member
Jason Weathersby wrote on Thu, 29 September 2011 11:12
Remove it from the jar files and use the manage drivers button in the
jdbc data source or just copy it to
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers

Jason

On 9/29/2011 3:29 AM, bppt wrote:
> "jar files"


thanks Jason.
the version of eclipse i used is "eclipse-java-galileo-SR1-win32"

I have followed your instructions.
--> the "jar file" that i mention exactly the same as your described. It is the "JDBC data source" --> "manage drivers" --> "add" "mysql-connector-java-5.1.15-bin.jar"
after that i config.
Driver class : com.mysql.jdbc.driver(v5.1)
Database URL : jdbc:mysql://localhost/mysql
User Name : root
Password : xxxxx

But still no response after clicked "test connection"

--> then i tried to remove the "jar", close eclipse, copy the "muysql......jar" to "eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers", restart "eclipse -clean" , go back to jdbc data source, i found this "com.mysql.jdbc.driver(v5.1)" from driver class again. Very Happy

but i still got the same problem.

Finally , i gave up this version of eclipse ( not sure about the version )
I tried to download the latest eclipse with birt and extract it into another new folder, created another new workspace and performed the same procedures.
Then, it is done!

I wonder there are some conflict between different plugin ( android ,..... )
So a clean version is ok.
Re: jdbc driver [message #731924 is a reply to message #731441] Mon, 03 October 2011 13:49 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

May be a conflict with the driver version. I have used that version
with mysql-connector-java-5.0.4-bin.jar and it worked for me.

Jason

On 9/30/2011 10:48 PM, bppt wrote:
> Jason Weathersby wrote on Thu, 29 September 2011 11:12
>> Remove it from the jar files and use the manage drivers button in the
>> jdbc data source or just copy it to
>> eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
>>
>> Jason
>>
>> On 9/29/2011 3:29 AM, bppt wrote:
>> > "jar files"
>
>
> thanks Jason.
> the version of eclipse i used is "eclipse-java-galileo-SR1-win32"
>
> I have followed your instructions.
> --> the "jar file" that i mention exactly the same as your described. It
> is the "JDBC data source" --> "manage drivers" --> "add"
> "mysql-connector-java-5.1.15-bin.jar"
> after that i config.
> Driver class : com.mysql.jdbc.driver(v5.1)
> Database URL : jdbc:mysql://localhost/mysql
> User Name : root
> Password : xxxxx
>
> But still no response after clicked "test connection"
>
> --> then i tried to remove the "jar", close eclipse, copy the
> "muysql......jar" to
> "eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers",
> restart "eclipse -clean" , go back to jdbc data source, i found this
> "com.mysql.jdbc.driver(v5.1)" from driver class again. :d
> but i still got the same problem.
>
> Finally , i gave up this version of eclipse ( not sure about the version )
> I tried to download the latest eclipse with birt and extract it into
> another new folder, created another new workspace and performed the same
> procedures.
> Then, it is done!
>
> I wonder there are some conflict between different plugin ( android
> ,..... )
> So a clean version is ok.
Re: jdbc driver [message #731927 is a reply to message #731441] Mon, 03 October 2011 13:49 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

May be a conflict with the driver version. I have used that version
with mysql-connector-java-5.0.4-bin.jar and it worked for me.

Jason

On 9/30/2011 10:48 PM, bppt wrote:
> Jason Weathersby wrote on Thu, 29 September 2011 11:12
>> Remove it from the jar files and use the manage drivers button in the
>> jdbc data source or just copy it to
>> eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers
>>
>> Jason
>>
>> On 9/29/2011 3:29 AM, bppt wrote:
>> > "jar files"
>
>
> thanks Jason.
> the version of eclipse i used is "eclipse-java-galileo-SR1-win32"
>
> I have followed your instructions.
> --> the "jar file" that i mention exactly the same as your described. It
> is the "JDBC data source" --> "manage drivers" --> "add"
> "mysql-connector-java-5.1.15-bin.jar"
> after that i config.
> Driver class : com.mysql.jdbc.driver(v5.1)
> Database URL : jdbc:mysql://localhost/mysql
> User Name : root
> Password : xxxxx
>
> But still no response after clicked "test connection"
>
> --> then i tried to remove the "jar", close eclipse, copy the
> "muysql......jar" to
> "eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers",
> restart "eclipse -clean" , go back to jdbc data source, i found this
> "com.mysql.jdbc.driver(v5.1)" from driver class again. :d
> but i still got the same problem.
>
> Finally , i gave up this version of eclipse ( not sure about the version )
> I tried to download the latest eclipse with birt and extract it into
> another new folder, created another new workspace and performed the same
> procedures.
> Then, it is done!
>
> I wonder there are some conflict between different plugin ( android
> ,..... )
> So a clean version is ok.
Re: jdbc driver [message #749647 is a reply to message #730787] Tue, 25 October 2011 10:51 Go to previous messageGo to next message
bppt Missing name is currently offline bppt Missing nameFriend
Messages: 6
Registered: September 2011
Junior Member
Thx, Jason.

I can make it. I tried another new copies of eclipse.

The previous eclipse i used was integrated with ADB ... android things.

NOw, i have another problem, about the deployment,

i read empty report but i can do it in preview in eclipse.

My report is linked with JDBC:ODBC: DSN microsoft access .mdb/
pls.help thx.
Re: jdbc driver [message #750056 is a reply to message #749647] Tue, 25 October 2011 15:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Do you have the jdbc:odbc driver deployed?
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php#install_jdbc

Jason

On 10/25/2011 6:51 AM, bppt wrote:
> Thx, Jason.
>
> I can make it. I tried another new copies of eclipse.
>
> The previous eclipse i used was integrated with ADB ... android things.
>
> NOw, i have another problem, about the deployment,
>
> i read empty report but i can do it in preview in eclipse.
>
> My report is linked with JDBC:ODBC: DSN microsoft access .mdb/
> pls.help thx.
Re: jdbc driver [message #751820 is a reply to message #750056] Wed, 26 October 2011 07:10 Go to previous messageGo to next message
bppt Missing name is currently offline bppt Missing nameFriend
Messages: 6
Registered: September 2011
Junior Member
Yes, i have followed the instructions on manual.

I copied rt.jar from java/lib into WebViewer's classpath (eg WEB-INF/lib).

And the log :
2011-10-25 10:55:19 org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
: Unable to open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides..
Re: jdbc driver [message #752764 is a reply to message #751820] Wed, 26 October 2011 14:06 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I had forgotten this driver was in rt.jar. Remove it from the
web-inf/lib because it should already be in the classpath. If you are
using windows 7, did you add the mdb to the using the odbcad32.exe under
%WINDIR%\SYSWOW64?

Jason

On 10/26/2011 3:10 AM, bppt wrote:
> Yes, i have followed the instructions on manual.
>
> I copied rt.jar from java/lib into WebViewer's classpath (eg WEB-INF/lib).
> And the log :
> 2011-10-25 10:55:19
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
> : Unable to open connection.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
> in get connection, [Microsoft][ODBC Microsoft Access Driver] '(unknown)'
> is not a valid path. Make sure that the path name is spelled correctly
> and that you are connected to the server on which the file resides..
Previous Topic:Asynchrony Testing
Next Topic:Math formulas in a BIRT report
Goto Forum:
  


Current Time: Wed Nov 26 03:24:49 GMT 2014

Powered by FUDForum. Page generated in 0.01927 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software