Eclipse Community Forums: ServerTools (WTP) » [WTP0.7M5] Server Explorer vs. MySQL 4.1

Home » Language IDEs » ServerTools (WTP) » [WTP0.7M5] Server Explorer vs. MySQL 4.1

[WTP0.7M5] Server Explorer vs. MySQL 4.1 [message #117753]

Thu, 07 July 2005 17:04

Eclipse User

Originally posted by: jens.ja-web.de

I tried the server explorer view but it does not like my local MySQL 4.1
database instance.

The connection setup seems fine.
I can open the created Connection without errors.
I can open a SQL Scrapbook and execute queries against the choosen database.

The Server explorer shows a Tree of server, schema, database, elements
for the open connection but it does not show any entries in the Folder
"Tables" or "Views"

When I try to open the "Tables" Folder I get an exeption that starts like
java.sql.SQLException: Column 'Type' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:910)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4942)
at
org.eclipse.wst.rdb.internal.core.connection.ResultSetAdapte r.getString(ResultSetAdapter.java:255)
at
org.eclipse.wst.rdb.internal.mysql.catalog.MySqlCatalogSchem a.loadTables(MySqlCatalogSchema.java:93)
at
org.eclipse.wst.rdb.internal.mysql.catalog.MySqlCatalogSchem a.getTables(MySqlCatalogSchema.java:57)
at
org.eclipse.wst.rdb.internal.core.containment.SchemaContainm entProvider.getContainedElements(SchemaContainmentProvider.j ava:25)

driver for the connection is mysql-connector-java-3.1.10-bin.jar

any ideas what's wrong here?
Jens

Re: [WTP0.7M5] Server Explorer vs. MySQL 4.1 [message #117900 is a reply to message #117753]

Fri, 08 July 2005 06:09

Eclipse User

Originally posted by: ossipetz.myrealbox.com

Jens Ansorg wrote:
> I tried the server explorer view but it does not like my local MySQL 4.1
> database instance.
>
> When I try to open the "Tables" Folder I get an exeption that starts like
> java.sql.SQLException: Column 'Type' not found.

you probably updated your db from an earlier version?
if so you must follow the update instructions from 4.0 to 4.1 since this
table changed. there is a tool which 'repairs' theses tables if this is
the case but i dont remember. but its in the update instructions :)

good luck!

Re: [WTP0.7M5] Server Explorer vs. MySQL 4.1 [message #120413 is a reply to message #117753]

Wed, 13 July 2005 05:07

Eclipse User

Hi Jens,

I get the same exception like you when I click to see the db-tables. The
connection to the db is made correctly. I use MYSQL 4.1 and WTP 1.0M5. I
didn't upgrade from MYSQL 4.0. Did you resolve the problem? Please let me
know!

Thanks
Matthias

"Jens Ansorg" <jens@ja-web.de> schrieb im Newsbeitrag
news:dak5d5$ld7$1@news.eclipse.org...
> I tried the server explorer view but it does not like my local MySQL 4.1
> database instance.
>
> The connection setup seems fine.
> I can open the created Connection without errors.
> I can open a SQL Scrapbook and execute queries against the choosen
database.
>
> The Server explorer shows a Tree of server, schema, database, elements
> for the open connection but it does not show any entries in the Folder
> "Tables" or "Views"
>
> When I try to open the "Tables" Folder I get an exeption that starts like
> java.sql.SQLException: Column 'Type' not found.
> at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:910)
> at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4942)
> at
>
org.eclipse.wst.rdb.internal.core.connection.ResultSetAdapte r.getString(Resu
ltSetAdapter.java:255)
> at
>
org.eclipse.wst.rdb.internal.mysql.catalog.MySqlCatalogSchem a.loadTables(MyS
qlCatalogSchema.java:93)
> at
>
org.eclipse.wst.rdb.internal.mysql.catalog.MySqlCatalogSchem a.getTables(MySq
lCatalogSchema.java:57)
> at
>
org.eclipse.wst.rdb.internal.core.containment.SchemaContainm entProvider.getC
ontainedElements(SchemaContainmentProvider.java:25)
>
>
> driver for the connection is mysql-connector-java-3.1.10-bin.jar
>
> any ideas what's wrong here?
> Jens

Previous Topic:	Hang's on build new Projekt
Next Topic:	problem with tomcat on eclipse 3.1

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Apr 18 08:24:40 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter